[dbo].[AddressTypeRef]

Property	Value
Created	10:31:13 AM Tuesday, March 02, 2010
Last Modified	11:40:00 AM Monday, February 20, 2012

Property

Value

Created

10:31:13 AM Tuesday, March 02, 2010

Last Modified

11:40:00 AM Monday, February 20, 2012

Name	Data Type	Max Length (Bytes)	Default
AddressTypeKey	uniqueidentifier	16
AddressTypeName	nvarchar(20)	40
IsSystem	bit	1	((0))
IsActive	bit	1
DisplayOrder	smallint	2
AddressCategoryCode	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

Default

AddressTypeKey

uniqueidentifier

AddressTypeName

nvarchar(20)

IsSystem

bit

((0))

IsActive

bit

DisplayOrder

smallint

AddressCategoryCode

int

	Name	Columns	Unique
	PK_AddressTypeRef	AddressTypeKey
	AK_AddressTypeRef_AddressTypeName	AddressTypeName

Name

Columns

Unique

PK_AddressTypeRef

AddressTypeKey

AK_AddressTypeRef_AddressTypeName

AddressTypeName

Name	Columns
FK_AddressTypeRef_CommunicationMechanismRef	AddressCategoryCode->[dbo].[AddressCategoryRef].[AddressCategoryCode]

Name

Columns

FK_AddressTypeRef_CommunicationMechanismRef

AddressCategoryCode->[dbo].[AddressCategoryRef].[AddressCategoryCode]

SQL Script

CREATE TABLE [dbo].[AddressTypeRef]
(
[AddressTypeKey] [uniqueidentifier] NOT NULL,
[AddressTypeName] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[IsSystem] [bit] NOT NULL CONSTRAINT [DF_AddressTypeRef_IsSystem] DEFAULT ((0)),
[IsActive] [bit] NOT NULL,
[DisplayOrder] [smallint] NOT NULL,
[AddressCategoryCode] [int] NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[AddressTypeRef] ADD CONSTRAINT [PK_AddressTypeRef] PRIMARY KEY CLUSTERED ([AddressTypeKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AddressTypeRef] ADD CONSTRAINT [AK_AddressTypeRef_AddressTypeName] UNIQUE NONCLUSTERED ([AddressTypeName]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AddressTypeRef] ADD CONSTRAINT [FK_AddressTypeRef_CommunicationMechanismRef] FOREIGN KEY ([AddressCategoryCode]) REFERENCES [dbo].[AddressCategoryRef] ([AddressCategoryCode])
GO